package com.ruoyi.db.mapper;

import com.ruoyi.db.domain.MemberExtInfo;
import com.ruoyi.db.model.param.MemberExtInfoParam;
import com.ruoyi.db.model.param.SpecialDataParam;
import com.ruoyi.db.model.vo.DataInfoVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 用户扩展信息Mapper接口
 * 
 * @author ruoyi
 * @date 2022-08-02
 */
public interface MemberExtInfoMapper 
{

    public Long countAuthNumber(@Param("dateInfo") String dateInfo);

    public Long countAuthNumberByDate(@Param("startDate") String startDate, @Param("endDate") String endDate);

    public Long countAuthNumberByDateAndProvince(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("provinceCode") String provinceCode);

    List<Map<String, Object>> countProvinceAuthNumberByDate(@Param("startDate")String startDate, @Param("endDate") String endDate);

    public List<Map<String, Object>> getAuthInfoByDateAndProvince(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("provinceCode") String provinceCode);

    /**
     * 查询用户扩展信息
     * 
     * @param uid 用户扩展信息主键
     * @return 用户扩展信息
     */
    public MemberExtInfo selectMemberExtInfoByUid(Long uid);

    /**
     * 查询用户扩展信息列表
     * 
     * @param memberExtInfo 用户扩展信息
     * @return 用户扩展信息集合
     */
    public List<MemberExtInfo> selectMemberExtInfoList(MemberExtInfo memberExtInfo);

    /**
     * 查询用户扩展信息列表
     *
     * @param memberExtInfo 用户扩展信息
     * @return 用户扩展信息集合
     */
    public List<Map<String, Object>> selectMemberExtInfoListMap(MemberExtInfoParam memberExtInfo);

    /**
     * 新增用户扩展信息
     * 
     * @param memberExtInfo 用户扩展信息
     * @return 结果
     */
    public int insertMemberExtInfo(MemberExtInfo memberExtInfo);

    /**
     * 修改用户扩展信息
     * 
     * @param memberExtInfo 用户扩展信息
     * @return 结果
     */
    public int updateMemberExtInfo(MemberExtInfo memberExtInfo);

    /**
     * 删除用户扩展信息
     * 
     * @param uid 用户扩展信息主键
     * @return 结果
     */
    public int deleteMemberExtInfoByUid(Long uid);

    /**
     * 批量删除用户扩展信息
     * 
     * @param uids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteMemberExtInfoByUids(String[] uids);

    List<MemberExtInfo> getDataListByCreateTime(@Param("datetime") String datetime, @Param("city") String city);

    Integer getDataSortZhimaInfo(@Param("dateInfo")String startTime, @Param("zhiMa")String zhiMa);

    List<DataInfoVO> getZhimaCountInfoByDateInfoAndChannelCode(@Param("dateInfo")String dateInfo, @Param("channelCode")String channelCode);

    List<DataInfoVO> getAuthCountInfoByDateInfoAndChannelCode(@Param("dateInfo")String dateInfo,@Param("channelCode") String channelCode);

    DataInfoVO getAgeCountInfoByDateInfoAndChannelCode(@Param("dateInfo")String dateInfo, @Param("channelCode")String channelCode, @Param("min")Integer min, @Param("max")Integer max);

    List<Map<String, Object>> getCityCountInfoByDateInfoAndChannelCode(@Param("dateInfo")String dateInfo, @Param("channelCode")String channelCode);

    Long getCountNumberByCountInfo(@Param("dateInfo")String dateInfo, @Param("channelCode")String channelCode);

    Long getCountNumberByDatetime(@Param("starttime")String starttime, @Param("endtime")String endtime);

    void deleteMemberExtInfoByMobile(@Param("mobile") String mobile);

    List<Map<String, Object>> getAuthInfo100City(@Param("startDate") String startDate,@Param("endDate")  String endDate);
}
